Job Overview
We are actively seeking a skilled Database Designer to become a vital part of our dynamic team. In this remote role, you will play a key role in the creation and development of databases that support critical business applications. While your primary focus will be on crafting business intelligence solutions, you will also engage with other essential systems. You will work collaboratively with our Database Administration (DBA) team, application developers, business analysts, and end-users to understand their requirements and develop efficient, scalable database solutions. Additionally, you will assist in optimizing performance and resolving any database-related challenges.
Key Responsibilities
- Collaborate with DBA teams, developers, analysts, and end-users to assess needs and propose effective database solutions.
- Design and implement comprehensive database structures, including tables, views, stored procedures, and other database components.
- Diagnose and troubleshoot data-related issues and performance bottlenecks, suggesting improvements for enhanced efficiency.
- Act as a liaison between the application development team and the DBA support team to ensure alignment and support.
- Adhere to corporate change management protocols in all database-related activities.
- Provide assistance on data integration projects and occasionally contribute to ETL (Extract, Transform, Load) and report development efforts.
Required Skills
- 7-10 years of practical experience in relational database development, including designing tables, views, stored procedures, and complex queries.
- 5-7 years of experience in database design and modeling for both relational and analytical systems.
- 5-7 years of experience in developing databases within Business Intelligence/Data Warehouse environments.
- Strong proficiency in MS SQL Server database design and development.
- Excellent written, verbal, and interpersonal communication skills.
- A solid understanding of various Software Development Lifecycles (Waterfall, Agile, Iterative, etc.).
- Experience with Erwin Data Modeling software is preferred.
- Familiarity with contemporary database and storage technologies such as Azure, Data Lakes, and NoSQL is advantageous.
- Experience with PowerBI modeling and report generation is a plus.
- Knowledge of ETL technologies and IBM DB2 is also a plus.
Qualifications
- A Bachelor’s degree in Computer Science, Information Technology, or a related field is preferred.
- Minimum of 7 years of relevant experience in database design and development.
Career Growth Opportunities
This position offers significant opportunities for professional development and career advancement as you engage with various departments and contribute to critical business applications. You will be part of a collaborative environment that promotes growth and learning within the organization.
Company Culture And Values
We pride ourselves on fostering a collaborative and growth-oriented work culture where team members support one another in achieving shared goals and personal development.
Compensation And Benefits
- Competitive salary based on experience, ranging from \(120,000 to \)140,000 per year.
- Potential for a hybrid work model after an initial onsite period.
- A supportive and forward-thinking work environment that emphasizes teamwork and professional development.
Employment Type: Full-Time